{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Page1","Page2","Reimbursement Schedule"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Page1","index":0,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,7,6,8],[8,6,8,7],[51,1,51,3],[52,1,52,3],[53,1,53,3],[12,7,12,8],[12,5,12,6],[40,1,40,3],[45,1,45,3],[39,1,39,3],[29,1,29,3],[30,1,30,3],[22,1,22,3],[24,1,24,3],[19,1,19,3],[20,1,20,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[70,1,70,3],[71,1,71,3],[64,1,64,3],[56,1,56,3],[57,1,57,3],[4,0,4,8],[15,7,15,8],[37,1,37,3],[47,1,47,3],[49,1,49,3],[50,1,50,3],[6,0,6,1],[6,2,6,3],[12,2,12,3],[32,1,32,3],[31,1,31,3],[28,1,28,3],[58,1,58,3],[63,1,63,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[54,1,54,3],[21,1,21,3],[25,1,25,3],[14,7,14,8],[23,1,23,3],[18,1,18,3],[14,5,14,6],[46,1,46,3],[38,1,38,3],[33,1,33,3],[35,1,35,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[36,1,36,3]]}
[]
[]
[null,null,null,null,null,null,null,null,"Page 1 of 2"]
[]
["REQUEST FOR TITLE III BUDGET REVISION: B, D or E"]
[]
["Fiscal Year:",null,null,null,null,null,"Title: III-"]
[null,null,null,null,null,null,null,"(B, D or E)"]
["Agency Name:"]
[]
["Agency Contact for Revision Questions:"]
[]
["Phone Number:",null,null,null,null,"Date of Request:"]
[]
[null,null,null,null,null,"Date of Last Revision:"]
[]
[]
["A.  Total FUNDS for all services"]
[null,null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","AAAL/Federal Funds",null,null,null,null,{"$f":"F20-E20","v":0},{"$f":"IF(G20=0,\"\",G20/E20)","v":""}]
["b.","Local Cash Match*",null,null,null,null,0,{"$f":"IF(G21=0,\"\",G21/E21)","v":""}]
["c.","Local Inkind Match*",null,null,null,null,0,""]
["d.","Project Income (Client Contributions)",null,null,null,null,0,""]
["e.","TOTAL",null,null,{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},0,""]
["f.","Federal share of net cost",null,null,{"$f":"IF(E24=0,\"\",E20/(E24-E23))","v":""},{"$f":"IF(F24=0,\"\",F20/(F24-F23))","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["g.","Non-federal share of net cost",null,null,{"$f":"IF(E24=0,\"\",(E21+E22)/(E24-E23))","v":""},{"$f":"IF(F24=0,\"\",(F21+F22)/(F24-F23))","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["B.  Total COSTS for each services"]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F30-E30","v":0},{"$f":"IF(G30=0,\"\",G30/E30)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F31-E31","v":0},{"$f":"IF(G31=0,\"\",G31/E31)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F32-E32","v":0},{"$f":"IF(G32=0,\"\",G32/E32)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F33-E33","v":0},{"$f":"IF(G33=0,\"\",G33/E33)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E30:E33)","v":0},{"$f":"SUM(F30:F33)","v":0},{"$f":"F34-E34","v":0},{"$f":"IF(G34=0,\"\",G34/E34)","v":""}]
[]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F37-E37","v":0},{"$f":"IF(G37=0,\"\",G37/E37)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F38-E38","v":0},{"$f":"IF(G38=0,\"\",G38/E38)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F39-E39","v":0},{"$f":"IF(G39=0,\"\",G39/E39)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F40-E40","v":0},{"$f":"IF(G40=0,\"\",G40/E40)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E37:E40)","v":0},{"$f":"SUM(F37:F40)","v":0},{"$f":"F41-E41","v":0},{"$f":"IF(G41=0,\"\",G41/E41)","v":""}]
[]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F44-E44","v":0},{"$f":"IF(G44=0,\"\",G44/E44)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F45-E45","v":0},{"$f":"IF(G45=0,\"\",G45/E45)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F46-E46","v":0},{"$f":"IF(G46=0,\"\",G46/E46)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F47-E47","v":0},{"$f":"IF(G47=0,\"\",G47/E47)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E44:E47)","v":0},{"$f":"SUM(F44:F47)","v":0},{"$f":"F48-E48","v":0},{"$f":"IF(G48=0,\"\",G48/E48)","v":""}]
[]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F51-E51","v":0},{"$f":"IF(G51=0,\"\",G51/E51)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F52-E52","v":0},{"$f":"IF(G52=0,\"\",G52/E52)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F53-E53","v":0},{"$f":"IF(G53=0,\"\",G53/E53)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F54-E54","v":0},{"$f":"IF(G54=0,\"\",G54/E54)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E51:E54)","v":0},{"$f":"SUM(F51:F54)","v":0},{"$f":"F55-E55","v":0},{"$f":"IF(G55=0,\"\",G55/E55)","v":""}]
[]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F58-E58","v":0},{"$f":"IF(G58=0,\"\",G58/E58)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F59-E59","v":0},{"$f":"IF(G59=0,\"\",G59/E59)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F60-E60","v":0},{"$f":"IF(G60=0,\"\",G60/E60)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F61-E61","v":0},{"$f":"IF(G61=0,\"\",G61/E61)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E58:E61)","v":0},{"$f":"SUM(F58:F61)","v":0},{"$f":"F62-E62","v":0},{"$f":"IF(G62=0,\"\",G62/E62)","v":""}]
[]
["Service:",null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,null,null,{"$f":"F65-E65","v":0},{"$f":"IF(G65=0,\"\",G65/E65)","v":""}]
["b.","Travel",null,null,null,null,{"$f":"F66-E66","v":0},{"$f":"IF(G66=0,\"\",G66/E66)","v":""}]
["c.","Equipment/Supplies***",null,null,null,null,{"$f":"F67-E67","v":0},{"$f":"IF(G67=0,\"\",G67/E67)","v":""}]
["d.","Other",null,null,null,null,{"$f":"F68-E68","v":0},{"$f":"IF(G68=0,\"\",G68/E68)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E65:E68)","v":0},{"$f":"SUM(F65:F68)","v":0},{"$f":"F69-E69","v":0},{"$f":"IF(G69=0,\"\",G69/E69)","v":""}]
[]
[null,"All Services",null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
["a.","Personnel/Fringe**",null,null,{"$f":"E30+E37+E44+E51+E58+E65","v":0},{"$f":"F30+F37+F44+F51+F58+F65","v":0},{"$f":"G30+G37+G44+G51+G58+G65","v":0},{"$f":"IF(G72=0,\"\",G72/E72)","v":""}]
["b.","Travel",null,null,{"$f":"E31+E38+E45+E52+E59+E66","v":0},0,0,{"$f":"IF(G73=0,\"\",G73/E73)","v":""}]
["c.","Equipment/Supplies***",null,null,0,0,0,{"$f":"IF(G74=0,\"\",G74/E74)","v":""}]
["d.","Other",null,null,0,0,0,{"$f":"IF(G75=0,\"\",G75/E75)","v":""}]
["e.","TOTAL",null,null,{"$f":"SUM(E72:E75)","v":0},{"$f":"SUM(F72:F75)","v":0},{"$f":"F76-E76","v":0},{"$f":"IF(G76=0,\"\",G76/E76)","v":""}]
[]
["C.  Variance between Total Funds and Total Costs (should be zero):"]
[null,null,null,null,"CURRENT","REVISION","DIFFERENCE","% CHANGE"]
[null,null,null,"Total Funds",{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":""}]
[null,null,null,"Total Costs",{"$f":"E76","v":0},{"$f":"F76","v":0},{"$f":"G76","v":0},{"$f":"H76","v":""}]
[null,null,null,"Variance",{"$f":"E80-E81","v":0},{"$f":"F80-F81","v":0},{"$f":"G80-G81","v":0},{"$f":"H80-H81","v":{"$error":"#VALUE!"}}]
[]
["* Agencies may not reduce the amount of match from the original grant/contract."]
["** Any change in number of positions or salary scale must be identified and explained on Page 2."]
["*** List any equipment changes requested and provide an explanation for changes on page 2."]
[]
["Rev 10-05-2019"]

{"sheet":"Page2","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[38,0,38,2],[43,0,53,10],[37,1,37,2],[30,9,31,9],[30,10,31,10],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[56,0,66,10],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[34,1,34,2],[35,1,35,2],[18,0,19,2],[18,3,19,3],[14,0,14,2],[32,1,32,2],[33,1,33,2],[30,0,31,2],[1,4,1,9],[10,1,10,2],[11,1,11,2],[13,1,13,2],[6,0,7,2],[8,1,8,2],[9,1,9,2],[6,10,7,10],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,8,19,8],[18,9,19,9],[18,10,19,10],[27,0,27,2],[23,1,23,2],[22,1,22,2],[15,0,15,2],[18,7,19,7],[20,1,20,2],[21,1,21,2],[25,1,25,2],[26,0,26,2]]}
[null,null,null,null,"REQUEST FOR TITLE III BUDGET REVISION: B, D or E"]
[null,null,null,null,null,null,null,null,null,null,"Page 2 of 2"]
[null,null,null,null,"Agency:",{"$f":"IF(Page1!C9=0,\"\",Page1!C9)","v":""}]
[]
[]
["A.  CURRENT FUNDS (by service)"]
["SERVICE",null,null,"AAAL/\nFederal Funds","Local Cash Match","In-Kind Match","Project Income","Total Funds","# of Units","# of Clients","AAAL Unit Cost"]
[]
["a.",{"$f":"IF(Page1!B29:D29=0,\"\",Page1!B29:D29)","v":""},null,null,null,null,null,{"$f":"SUM(D9:G9)","v":0},null,null,{"$f":"IF(I9=0,\"\",D9/I9)","v":""}]
["b.",{"$f":"IF(Page1!B36:D36=0,\"\",Page1!B36:D36)","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I10=0,\"\",D10/I10)","v":""}]
["c.",{"$f":"IF(Page1!B43:D43=0,\"\",Page1!B43:D43)","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I11=0,\"\",D11/I11)","v":""}]
["d.",{"$f":"IF(Page1!B50:D50=0,\"\",Page1!B50:D50)","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I12=0,\"\",D12/I12)","v":""}]
["e.",null,null,null,null,null,null,0]
["f.",{"$f":"IF(Page1!B64:D64=0,\"\",Page1!B64:D64)","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I14=0,\"\",D14/I14)","v":""}]
["TOTALS",null,null,{"$f":"SUM(D9:D14)","v":0},0,0,0,0,0,0]
["TOTAL must match Pg. 1 Projections)",null,null,{"$f":"IF(Page1!E20=0,\"\",Page1!E20)","v":""},{"$f":"IF(Page1!F21=0,\"\",Page1!F21)","v":""},{"$f":"IF(Page1!E22=0,\"\",Page1!E22)","v":""},{"$f":"IF(Page1!E23=0,\"\",Page1!E23)","v":""},{"$f":"IF(Page1!E24=0,\"\",Page1!E24)","v":""},{"$f":"SUM(I9:I14)","v":0},{"$f":"SUM(J9:J14)","v":0}]
[]
["B.  REQUESTED REVISION (by service)"]
["SERVICE",null,null,"AAAL/\nFederal Funds","Local Cash Match","In-Kind Match","Project Income","Total Funds","# of Units","# of Clients","AAAL Unit Cost"]
[]
["a.",{"$f":"B9","v":""},null,null,null,null,null,{"$f":"SUM(D21:G21)","v":0},null,null,{"$f":"IF(I21=0,\"\",D21/I21)","v":""}]
["b.",{"$f":"B10","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I22=0,\"\",D22/I22)","v":""}]
["c.",{"$f":"B11","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I23=0,\"\",D23/I23)","v":""}]
["d.",{"$f":"B12","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I24=0,\"\",D24/I24)","v":""}]
["e.",null,null,null,null,null,null,0]
["f.",{"$f":"B14","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(I26=0,\"\",D26/I26)","v":""}]
["TOTALS",null,null,{"$f":"SUM(D21:D26)","v":0},0,0,0,0,0,0]
["TOTAL must match Pg. 1 Projections)",null,null,{"$f":"IF(Page1!F20=0,\"\",Page1!F20)","v":""},{"$f":"IF(Page1!F21=0,\"\",Page1!F21)","v":""},{"$f":"IF(Page1!F22=0,\"\",Page1!F22)","v":""},{"$f":"IF(Page1!F23=0,\"\",Page1!F23)","v":""},{"$f":"IF(Page1!F24=0,\"\",Page1!F24)","v":""},{"$f":"SUM(I21:I26)","v":0},{"$f":"SUM(J21:J26)","v":0}]
[]
["C.  DIFFERENCE (by service) This section is for Area Agency on Aging for Lincolnland use only."]
["SERVICE",null,null,"AAAL/\nFederal Funds","Local Cash Match","In-Kind Match","Project Income","Total Costs","# of Units","# of Clients","AAAL Unit Cost"]
[]
["a.",{"$f":"B9","v":""},null,{"$f":"D21-D9","v":0},0,0,0,0,0,0,{"$f":"IF(I33=0,\"\",D33/I33)","v":""}]
["b.",{"$f":"B10","v":""},null,0,0,0,0,0,0,0,""]
["c.",{"$f":"B11","v":""},null,0,0,0,0,0,0,0,""]
["d.",{"$f":"B12","v":""},null,0,0,0,0,0,0,0,""]
["e.",null,null,0,0,0,0,0,0,0,""]
["f.",{"$f":"B14","v":""},null,{"$f":"D26-D14","v":0},0,0,0,0,0,0,""]
["TOTALS",null,null,{"$f":"SUM(D33:D38)","v":0},0,0,0,0,0,0]
[]
["For the narrative questions below, attach additional sheets as needed:"]
[]
["1.  Please provide an explanation for any changes in unit rate."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.  Please provide rationale for any changes in resources and/or expenses categories."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Page1!A88","v":"Rev 10-05-2019"}]

{"sheet":"Reimbursement Schedule","index":2,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[9,12,10,12],[9,13,10,13],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[5,2,5,5],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5]]}
[]
[null,"Title III Reimbursement Schedule"]
[null,"Program:","Title III-",{"$f":"IF(Page1!H7=0,\"\",Page1!H7)","v":""},null,null,"Areas to enter are highlighted in yellow."]
[]
[null,"Fiscal Year:",{"$f":"IF(Page1!C7=0,\"\",Page1!C7)","v":""}]
[null,"Agency:",{"$f":"IF(Page1!C9=0,\"\",Page1!C9)","v":""}]
[null,"Submitted by:"]
[null,"Date Submitted:",{"$f":"IF(Page1!H13=0,\"\",Page1!H13)","v":""}]
[]
[null,"Month","AAAL Reimbursements received ","Estimation of Expenditures for the month","Total AAAL reimbursement (Sum of column a and b)","Pending available funding, Agencies will receive this reimbursment within 3 days of AAAL receipt of the funds","Program Income  received","Estimation of Program Income which will be collected & expended","Total Project Income (Sum of column e and f)"]
[]
[null,null,"a ","b","c","d","e","f","g"]
[1,"October",null,null,{"$f":"+D13+C13","v":0},"October",null,null,{"$f":"+H13+G13","v":0}]
[2,"November",null,null,0,"November",null,null,0]
[3,"December",null,null,0,"December",null,null,0]
[4,"January",null,null,0,"January",null,null,0]
[5,"February",null,null,0,"February",null,null,0]
[6,"March",null,null,0,"March",null,null,0]
[7,"April",null,null,0,"April",null,null,0]
[8,"May ",null,null,0,"May ",null,null,0]
[9,"June",null,null,0,"June",null,null,0]
[10,"July",null,null,0,"July",null,null,0]
[11,"August",null,null,0,"August",null,null,0]
[12,"September",null,null,0,"September",null,null,0]
[13,"Total",{"$f":"SUM(C13:C24)","v":0},{"$f":"SUM(D13:D24)","v":0},{"$f":"SUM(E13:E24)","v":0},null,{"$f":"SUM(G13:G24)","v":0},{"$f":"SUM(H13:H24)","v":0},{"$f":"SUM(I13:I24)","v":0}]
[14,"NGA level",null,null,{"$f":"Page1!F20","v":0},null,null,null,{"$f":"Page1!F23","v":0}]
[15,"Difference (should be $0)",null,null,{"$f":"+E26-E25","v":0},null,null,null,{"$f":"+I26-I25","v":0}]
[null,"Report should be sent to Reports Portal at www. aginglinc.org with Budget Revision."]
[null,"I certify that this report is the best estimate of our AAAL Expenditures ",null,null,null,null,null,"          Check this box if you "]
[null,"and estimated Project Income collected.",null,null,null,null,null,"would like to suppress paper"]
[null,"A signed copy may be scanned or faxed and sent to AAAL.",null,null,null,null,null,"and receive email notification "]
[null,null,null,null,null,null,null,"of payments."]
[]
[null,"Signature",null,null,null,"Date"]
[]
[null,"Name (printed)",null,null,null,"Title"]
[]
[]
[null,"Prepared by",null,null,null,"Phone number of preparer"]
[]
[null,"Send payment email notification to:"]
[null,"Email notifications will be sent to this email address only if box is checked (see above)."]
[]
[null,{"$f":"Page1!A88","v":"Rev 10-05-2019"}]